| AdGPAStudentCourse |
| Logical Entity Name | AdGPAStudentCourse |
| Default Table Name | AdGPAStudentCourse |
| Physical Only | NO |
| Definition | |
| Note |
| AdGPAStudentCourse Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
AdGPAStudentCourseID |
int | NO | ||
SyStudentID |
int | NO | ||
AdGPAID |
int | NO | ||
AdEnrollSchedID |
int | YES | ||
| AdTermID | int | YES | ||
AmCollegeTransferID |
int | YES | ||
| IncludeInCumGPA | bit | NO | ||
| IncludeInTermGPA | bit | NO | ||
| IncludeInDefault | bit | NO | ||
| DefaultInCum | bit | NO | ||
| DefaultInTerm | bit | NO | ||
| UnitsAttempt | numeric(9, 4) | YES | ||
| UnitsEarned | numeric(9, 4) | YES | ||
| GradePoints | numeric(9, 4) | YES | ||
| QualityPoints | numeric(15, 6) | YES | ||
| QualityUnits | numeric(9, 4) | YES | ||
| ManualOverride | bit | YES | ||
| RemovedByRetake | bit | YES | ||
UserID |
int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO |
| AdGPAStudentCourse Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK_AdGPAStudentCourse_AdGPAStudentCourseID | PrimaryKey | AdGPAStudentCourseID |
| AdGPAStudentCourse Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| AdEnrollSched | Non-Identifying | Zero or One to Zero or More | FK_AdGPAStudentCourseAdEnrollSchedID_AdEnrollSchedAdEnrollSchedID | AdEnrollSchedID | NO | YES | ||
| AdGPA | Non-Identifying | One To Zero or More | FK_AdGPAStudentCourseAdGPAID_AdGPACourseAdGPAID | AdGPAID | NO | YES | ||
| AmCollegeTransfer | Non-Identifying | Zero or One to Zero or More | FK_AdGPAStudentCourseAmCollegeTransferID_AmCollegeTransferAmCollegeTransferID | AmCollegeTransferID | NO | YES | ||
| syStudent | Non-Identifying | One To Zero or More | FK_AdGPAStudentCourseSyStudentID_SyStudentSyStudentID | SyStudentID | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_AdGPAStudentCourseUserID_SyStaffSyStaffID | UserID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| AdGPAStudentCourse Check Constraints |
| Check Constraint Name | CheckConstraint |